<?php
/*
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT=0;
START TRANSACTION;

TRUNCATE table fitz_store;
TRUNCATE table fitz_product;

insert into fitz_store (
id,code,name,directDial,
contactName,address,suburb,city,
state,postcode,contactPhone,contactFax,
contactMobile,contactEmail,manager,managerEmail,
administrator
) ( select 
id,code,name,direct_dial,
contact_name,address,suburb,city,
state,post_code,contact_phone,contact_fax,
contact_mobile,contact_email,'','',
'' from  stores);

insert into fitz_product
(
id,name,model,description,type
)
(select 
id,name,model_description,'',product_type
from products where name <>''
);

SET FOREIGN_KEY_CHECKS=1;
COMMIT;


 * 
 */